-
Report Sorting on Non-Included Columns
Right now, on reports, you can add a column, sort by it, and then remove the column and the sort remains (at least when I test it, it does). However the Sort menu shows blanks. This can also be a ted…2 · -
INDEX MATCH and COLLECT all at once
I have used INDEX({Array},MATCH(Value in Column),MATCH(Value in Row)) to retrieve a value by matching the column and row I have used INDEX(COLLECT(Reference Column, Criteria 1, Criteria 2)) to collec…1 · -
Extracting email information from a contact column
I have a need to extract email information from the information in a contact column. My users occasionally need to copy and past email information into other applications. I know that if I reference …1 · -
Re: Dashboard Timeline
This is an older thread, but hopefully Andree will still see this response. Andree, you state "import the Gantt Chart to the add-on called Office Timeline and show that on the dashboard". …2 · -
Copying contact information from one sheet to another
If my users attempt to copy contacts from one sheet to another, they loose the total contact information. Only the name, as text comes over. Even if both column types are Contact. There does not seem…2 ·